des

-----------------
//DESCRITPIVES
*Use final sample
//6 obs dropped due to no CAFR data for gfbalance_
oprobit reorganization centralized1 centralized2 participatory2 participatory1 gfbalance_ recovery2 pcprivjobs hmedinc_  lnpop  ethnic_frag  fun_indx pctprptx_ hierarchy formalization cm1 administrative polsupport mayor council union, cluster(d_state)

*Frequency analysis for organizational change and centralization/decentralization variables

tab centralized1 if e(sample)
tab centralized2 if e(sample)
tab participatory1 if e(sample)
tab participatory2 if e(sample)

tab reorganization  if  e(sample)
tab contracting if  e(sample)
tab technology  if  e(sample)
tab performance  if  e(sample)


*Correlation analysis
pwcorr performance technology reorganization contracting centralized1 centralized2 participatory2 participatory1 gfbalance_ recovery2 pcprivjobs hmedinc_  lnpop  ethnic_frag  fun_indx pctprptx_ hierarchy formalization cm1 administrative polsupport mayor council union if e(sample), sig

*Summary statistics for all variables
sum performance technology reorganization contracting centralized1 centralized2 participatory2 participatory1 gfbalance_ recovery2 pcprivjobs hmedinc_  lnpop  ethnic_frag  fun_indx pctprptx_ hierarchy formalization cm1 administrative polsupport mayor council union if e(sample)

-----------------
//ORIGINAL MODELS

---
*REORGANIZATION MODEL
oprobit reorganization centralized1 centralized2 participatory2 participatory1 gfbalance_ recovery2 pcprivjobs hmedinc_  lnpop  ethnic_frag  fun_indx pctprptx_ hierarchy formalization cm1 administrative  polsupport mayor council union, cluster(d_state)
//centralized2+

*Prepare value labels for graphs
label define centralized1_n 1 "Strongly Disagree" 2 "Disagree" 3 "Neutral" 4 "Agree" 5 "Strongly Agree"
label values centralized1 centralized1_n
tabulate  centralized1
label define centralized2_n 1 "Strongly Disagree" 2 "Disagree" 3 "Neutral" 4 "Agree" 5 "Strongly Agree"
label values centralized2 centralized2_n
tabulate  centralized2
label define participatory1_n 1 "Strongly Disagree" 2 "Disagree" 3 "Neutral" 4 "Agree" 5 "Strongly Agree"
label values participatory1 participatory1_n
tabulate  participatory1
label define participatory2_n 1 "Strongly Disagree" 2 "Disagree" 3 "Neutral" 4 "Agree" 5 "Strongly Agree"
label values participatory2 participatory2_n
tabulate  participatory2

*Graphs
//predict (pr)reorganization=heavily relied across centralized2
margins, predict(outcome(3)) at(centralized2=(2(1)5)) atmeans
marginsplot, title ("Reorganized local government" "(With 95% Confidence Intervals)") xtitle ("Moderate Centralization" "Strategies for dealing with major issues are usually formulated" "by a team of high-level city officials") ytitle("Pr(Heavily Relied)")
display .0974442   - .270357 //-.1729128


---
*CONTRACTING MODEL
oprobit contracting centralized1 centralized2  participatory2 participatory1  gfbalance_ recovery2 pcprivjobs hmedinc_  lnpop  ethnic_frag fun_indx pctprptx_ hierarchy formalization cm1 administrative polsupport mayor council union, cluster(d_state)
//centralized2+

*Graphs
//predict (pr)contracting=heavily relied across centralized2
margins, predict(outcome(3)) at(centralized2=(2(1)5)) atmeans
marginsplot, title ("Contracted out services" "(With 95% Confidence Intervals)") xtitle ("Moderate Centralization" "Strategies for dealing with major issues are usually formulated" "by a team of high-level city officials") ytitle("Pr(Heavily Relied)")
display .0310087   -  .1005136  // -.0695049


---
*TECHNOLOGY MODEL
oprobit technology centralized1 centralized2 participatory2 participatory1 gfbalance_ recovery2 pcprivjobs hmedinc_  lnpop  ethnic_frag  fun_indx pctprptx_ hierarchy formalization cm1 administrative polsupport mayor council union, cluster(d_state)
//centralized2+, participatory2+

*Graphs
//predict (pr)technology=heavily relied across centralized2
margins, predict(outcome(3)) at(centralized2=(2(1)5)) atmeans
marginsplot, title ("Promoted Greater Use of technology" "(With 95% Confidence Intervals)") xtitle ("Moderate Centralization" "Strategies for dealing with major issues are usually formulated" "by a team of high-level city officials") ytitle("Pr(Heavily Relied)")
display .06085  - .2040697 // -.1432197

//predict technology=heavily relied across participatory2
margins, predict(outcome(3)) at(participatory2=(1(1)5)) atmeans
marginsplot, title ("Promoted Greater Use of technology" "(With 95% Confidence Intervals)") xtitle ("Moderate Decentralization" "Most staff have input only on decisions that directly affect them") ytitle("Pr(Heavily Relied)")
display .0982576  - .2499676  // -.15171


---
//PERFORMANCE MODEL
oprobit performance centralized1 centralized2  participatory2 participatory1 gfbalance_ recovery2 pcprivjobs hmedinc_   lnpop  ethnic_frag fun_indx pctprptx_ hierarchy formalization cm1 administrative polsupport mayor council  union, cluster(d_state)

*Graphs
//predict (pr)performance=heavily relied across centralized2
margins, predict(outcome(3)) at(centralized2=(2(1)5)) atmeans
marginsplot, title ("Used performance information to improve service delivery" "(With 95% Confidence Intervals)") xtitle ("Moderate Centralization" "Strategies for dealing with major issues are usually formulated" "by a team of high-level city officials") ytitle("Pr(Heavily Relied)")
display  .0392199   - .1640761  //-.1248562

//predict (pr)performance=heavily relied across participatory2
margins, predict(outcome(3)) at(participatory2=(1(1)5)) atmeans
marginsplot, title ("Used performance information to improve service delivery" "(With 95% Confidence Intervals)") xtitle ("Moderate Decentralization" "Most staff have input only on decisions that directly affect them") ytitle("Pr(Heavily Relied)")
display .0649921 - .2207728   // -.1557807






